This model dimension represents Financial accounts and is based on the IFS Cloud dimension DIM_ACCOUNT. Most models that refer to this dimension will have the attributes and hierarchies as described below. Exceptions are the General Ledger and Group Consolidation models that also contain structure information related to:
Natural parent is company, i.e. each company has its on set of accounts.
| Attribute | Description (where applicable) |
| Account | Built as CODE + ' - ' + DESCRIPTION |
| Account Code | Represents the CODE of the dimension, i.e. account |
| Account Desc | Represents the description of the Account |
| Account Group | Represents COMPANY + ' - ' + ACCOUNT_GROUP + ' - ' + ACCOUNT_GROUP_DESC |
| Account Group Code | Represents the account group code |
| Account Group Desc | Represents the account group description |
| Account Type | Represents the COMPANY + ' - ' + ACCOUT_TYPE + ' - ' + ACCOUNT_TYPE_DESC |
| Account Type Code | Represents the account type code |
| Account Type Desc | Represents the account type description |
| Company | Represents the natural parent COMPANY |
| Company - Account | Built as COMPANY + ' - ' CODE + ' - ' + DESCRIPTION |
| Statement Type Code | Represents Statement Type Code |
| Statement Type | Represents Statement Type Description |
| Logical Account Type | Represents the Logical Account Type |
| Logical Account Type Code | Represents the Logical Account Type Code |
| Group Account | Represents the Group Account |
| Bs Structure ID | Bs Structure ID |
| Bs Value Description | Bs Value Description |
| Is Structure ID | Is Structure ID |
| Is Value Description | Is Value Description |
| Hierarchy | Level |
| AccountGroupHy | |
| Account Group | |
| Account | |
| AccountTypeHy | |
| Account Type | |
| Account | |
| BsHy | |
| BSL01 | |
| BSL02 | |
| BSL03 | |
| BSL04 | |
| BSL05 | |
| BSL06 | |
| BSL07 | |
| BSL08 | |
| BSL09 | |
| BSL10 | |
| IsHy | |
| ISL01 | |
| ISL02 | |
| ISL03 | |
| ISL04 | |
| ISL05 | |
| ISL06 | |
| ISL07 | |
| ISL08 | |
| ISL09 | |
| ISL10 |
| Model Name |
| Group Consolidation |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| ACCOUNT | DIM_ACCOUNT_GC_TM | DIM_ACCOUNT_BI | DIM_ACCOUNT | On Line |